Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# XMLCOMMENT

Syntax

Description of the illustration XMLComment.gif

Purpose

`XMLComment` generates an XML comment using an evaluated result of `value_expr`. The `value_expr` must resolve to a string. It cannot contain two consecutive dashes (hyphens). The value returned by the function takes the following form:

    <!--string-->

If `value_expr` resolves to null, then the function returns null.

See Also: Oracle XML DB Developer's Guide for more information on this function

Examples

The following example uses the `DUAL` table to illustrate the `XMLComment` syntax:

    SELECT XMLCOMMENT('OrderAnalysisComp imported, reconfigured, disassembled')
       AS "XMLCOMMENT" FROM DUAL;

    XMLCOMMENT
    --------------------------------------------------------------------------------
    <!--OrderAnalysisComp imported, reconfigured, disassembled-->